7 Year Balloon Loan
Use this template to calculate monthly loan payments and prepare an amortization schedule for a 7 year balloon loan. A balloon loan requires a large final payment at some future date. The advantage of such an arrangement is that the borrower makes payments based on a traditional mortgage term -- such as 15 or 30 years -- at an interest rate that reflects the typically lower annual rate of a shorter-term loan (7years). The loan amortization is any period that you choose and affects the monthly payment you will make during the seven years. You can lower the monthly payment by entering a longer amortization period. To view the template, click the worksheet tab labeled Template at the bottom of the screen or press Ctrl-PgDn. With the exception of data entry cells, all cells are protected. Use the Tab key to move from one unprotected cell to the next.
7 Year Balloon Loan Amortization
<-- Enter preparer's name in cell to the left
<-- Enter date prepared in cell to the left
Name Address City, State, Zip Telephone
Financial Inputs Loan Amount Interest Rate Period (in years) Loan Summary Information
Loan Date Loan Number Miscellaneous Appraised Value
Monthly Payment Total Interest Total Payments Balloon Payment
Amortization Schedule of 7 Year Balloon Loan
Beginning Mortgage Year Balance Total Monthly Payment Total Interest Portion Total Principal Portion Ending Mortgage Balance